DataWarehouse Detective: Schema Design Made Easy
نویسندگان
چکیده
The deployment of data warehouses (DWs), which are integrated databases to support decision making, has become common practice in modern information technology landscapes, and the methodical design process for such databases has been advanced significantly in recent years. In this context, we are investigating issues concerning the quality of DW schemata which can be measured and algorithmically enforced via multidimensional normal forms (MNFs) during conceptual design. So far, however, tool support for DW design based on MNFs has been missing, a gap which we are about to close.
منابع مشابه
Data Warehouse Schema Evolution and Adaptation Framework Using Ontology
Data Warehouse systems aim at integrating data from multiple heterogeneous, distributed, autonomous data sources. Due to changing business needs the data warehouse systems are never meant to be static. Changes in the data source structure or business requirements would result in the evolution of data warehouse schema structure. When data warehouse schema evolves the dependent modules such as it...
متن کاملA Methodology for Datawarehouse Design: Conceptual Modeling
Data warehousing and online analytical processing (OLAP) technologies have become growing interest areas in latest years. Specific issues, such as conceptual modeling, schemes translation from operational systems, physical design, etc... have been widely treated, but there is not a general accepted complete methodology for datawarehouse design. In this work, we present a multidimensional datawa...
متن کاملA Model for XML Instance Level Integration
There are two major problems for merging instances from different sources in order to build a datawarehouse: entity identification ambiguity and attribute value conflict. In this paper we propose a data model that facilitates the resolution of value attribute conflicts by explicitly representing them in the integrated schema. In this model, the datawarehouse is an XML tree populated with data i...
متن کاملModeling Herd Trajectory Data Warehouse
Studding the movement of animals and their behavior become an important subject. Indeed, such study can generate useful information used next to assist the decision makers involved in different domains such as agriculture, security, health care and business. We present in this work a trajectory model related to the displacement of the herd, which allows the generation of trajectory data that is...
متن کاملIntegration von ETL und OLAP in die relationale DWH-Technologie: mehr Lösung für weniger Aufwand?
Seit vielen Jahren werden Lösungen für Datawarehouse Themen schon nach dem gleichen Schema entwickelt. Dies ist nicht weiter verwunderlich, da doch die Anforderungen –eigentlichimmer ähnlich sind: Daten aus verschiedenen Quellsystemen sollen, unter diversen Randbedingungen, analysiert werden. Auch wenn sich Technologien weiter entwickelt haben, Schnittstellen nun bereits out-of-the-box verfügba...
متن کامل